2016-05-05 - 26983 - Service Request - AR220 - Formula Investigation #BExQueriesforCrystalReportsAnalysisTool

Service Request

26983- AR220 Formula Investigation

Problem Summary

---

Need to investigate if AR220 report can be built directly on FIAR DSO(0FIAR_O03) BEx Query instead of using another BEx query on infoset (ZIS_FIAR).

Admin Info

---

Purpose	Need to investigate if AR220 report can be built directly on FIAR DSO(0FIAR_O03) BEx Query instead of using another BEx query on infoset (ZIS_FIAR)
Requested by	Saravanan Lakshmanan
Issue Date	05/05/2016
Resolved by	Naveen G
Resolved Date	05/10/2016
Document Status	Complete

Detailed Problem Description

---

Investigate the formula for AR220 selection criteria and investigate whether a single BEx Query source can be used to replace the multiple BEx Queries used in the report.

Solution Analysis and Recommendations

---

Sales Group is not getting updated in FIAR DSO(0FIAR_O03), to get this values into AR220 report, BEx Query is created on top of it ZIS_FIAR and this is being used in AR220 report.
But the use of query created on top of infoset is creating performance issues, resulting in long run time of report.

Resolution

---

Instead of using Infoset, the same logic to lookup Sales Group can be included in FIAR DSO, but this requires initialization of data source & downtime is required.

Release Information

---

None